Incorporating Deviation-Detection Functionality into the OLAP Paradigm

نویسندگان

  • Carem C. Fabris
  • Alex Alves Freitas
چکیده

Although the integration of data mining and OLAP is obviously of great interest (if only due to the widespread availability of commercial-strength OLAP tools), relatively little progress has been made in this integration. The main goal of this paper is to contribute to this integration, by incorporating some data mining functionality (more precisely, deviation-detection functionality) into the OLAP paradigm. The data mining method addressed in this paper is Attribute Focusing. This method discovers interesting attribute values, in the sense that the observed frequency of those values deviate from their expected frequency. However, standard Attribute Focusing assumes that attribute values are “flat” (i.e. non-hierarchical), which is a serious limitation for its application in the OLAP paradigm. In order to make Attribute Focusing useful for OLAP we have adapted this method to the kind of hierarchical dimension often found in data cubes.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Improving the performance and functionality of Mondrian open-source OLAP systems

For a long time, the design of relational databases has focused on the optimization of atomic transactions (insert, select, update or delete). Currently, relational databases store tactical information of data warehouses, mainly for select-like operations. However, the database paradigm has evolved, and nowadays on-line analytical processing (OLAP) systems handle strategic information for furth...

متن کامل

The GOLD model: An Object Oriented multidimensional data model for multidimensional databases

There has recently been an increased interest in multidimensional databases (MDB) and On-line Analytical Processing (OLAP) scenarios. OLAP systems impose different requirements than On-line Transactional Processing (OLTP) systems, and therefore, different data models and implementation methods are required for each type of system. There have been several different multidimensional data models p...

متن کامل

Materializing Baseline Views for Deviation Detection Exploratory OLAP

Alert-raising and deviation detection in OLAP and exploratory search concerns calling the user’s attention to variations and nonuniform data distributions, or directing the user to the most interesting exploration of the data. In this paper, we are interested in the ability of a data warehouse to monitor continuously new data, and to update accordingly a particular type of materialized views re...

متن کامل

Visual Olap: a New Paradigm for Exploring Multidimensional Aggregates

OLAP (On-Line Analytical Processing) technology provides interactive query-driven analysis of accumulated and consolidated business data for the purpose of decision-making and knowledge extraction. Visualization is increasingly used as the means of gaining insight into huge data volumes of multidimensional data as the former exploits the profound ability of the human vision system to recognize ...

متن کامل

Bridging the Gap between OLAP and SQL

In the last ten years, database vendors have invested heavily in order to extend their products with new features for decision support. Examples of functionality that has been added are top N [2], ranking [13, 7], spreadsheet computations [19], grouping sets [14], data cube [9], and moving sums [15] in order to name just a few. Unfortunately, many modern OLAP systems do not use that functionali...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2001